Im in need of being able to split my data with several different seperators.
Im converting geogaphic info that is seperated with comma, and the software outputs the converted data with comma, but all the othe data like depth og height come separated with space. and there is a couple of { and} in there also.
So if i could separate the data with several separators, and then export it with only the rows i need it would be perfect.
Best regards
Kim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have updated ReCsvEditor to allow Regular-Expressions to be used to be used in a scchema.
This update is available as USB style download - Unzip the tin any normal unprotexted directory (not c:\Program DFiles). It is available at:
This change allows RegularExpresions to be used in schema's. You can view the file and Export as Csv but you can not update / Save the file. There is a Schema for you: RegularExpression.Xml. In the Schema there is
Hi
Tx for a great piece of software.
Im in need of being able to split my data with several different seperators.
Im converting geogaphic info that is seperated with comma, and the software outputs the converted data with comma, but all the othe data like depth og height come separated with space. and there is a couple of { and} in there also.
So if i could separate the data with several separators, and then export it with only the rows i need it would be perfect.
Best regards
Kim
Basically no, You can setup define array's (via xml schema) which may work ???
Array fields example (: used for array)
Can you provide sample data and a more detailed eplanation of what you want to achieve ???
hi
376513.782 6802065.212 {61.3330312,6.6923147,79.18,59}
376508.214 6802065.877 {61.3330354,6.6922103,76.59,54}
376509.145 6802065.844 {61.3330354,6.6922277,77.18,59}
I want this file to be separated by: Space , Comma, } and {
I have updated ReCsvEditor to allow Regular-Expressions to be used to be used in a scchema.
This update is available as
USBstyle download - Unzip the tin any normal unprotexted directory (not c:\Program DFiles). It is available at:This change allows RegularExpresions to be used in schema's. You can view the file and Export as Csv but you can not update / Save the file. There is a
Schemafor you:RegularExpression.Xml. In the Schema there isWhich will split a line into seperate fields.
For useage:
hopefully this is useful
Last edit: Bruce Martin 2019-09-27
Tx
Gona give it a try tomorrow
Kim
It works very well, tx