Digital White Papers

LPS20

publication of the International Legal Technology Association

Issue link: https://epubs.iltanet.org/i/1310179

Contents of this Issue

Navigation

Page 26 of 51

I L T A W H I T E P A P E R | L I T I G A T I O N A N D P R A C T I C E S U P P O R T 27 In this case the default option "Delimited" is appropriate, since the intention is to use the comma as the field separator: Note: as mentioned before, when working with loadfiles, other text editing tools may be more appropriate. Select the comma as the delimiter: and click Finish – the data has now been parsed into two separate fields: PARSING INFORMATION INTO SEPARATE FIELDS When the opposite is necessary, i.e. parsing information in one field into several fields. This requires some basic knowledge on delimiters. Select the column to be parsed and select the Text to Columns tool under the Data tab: This was a straight-forward example. However, depending on your data, the Fixed Width may produce better results. Attempt different scenarios and experiment until you find the right combination that suits your needs.

Articles in this issue

Archives of this issue

view archives of Digital White Papers - LPS20