| Wolfgang Homburg |
| Newbie |
|
| Kassel, Germany |
|
|
| None Specified |
|
| Friday, December 1, 2017 |
| Friday, January 11, 2019 2:27:01 PM |
3
[0.02% of all post / 0.00 posts per day] |
|
|
Sounds great, I'll try that.
|
|
Please find attached the FlexText configuration. However, it refers to the simplified CSV-File shortPauschForum.txt.
|
(I just started to work with MapForce ...)
I got a CSV-File (; is the separator) with following format (see attachment):
The fist line contains some column headings. The next lines have the same format and contain the data. They look as follows:
"SHEABR;4711;135580105;some text;1;2;8;Adam 1;03/08/1959;1038988;1;;Adam 2;03/08/1959;1238988;;1;Adam 3;03/08/1959;7038988;1;;..."
The items up to the first "Adam" are of no interest. After that some blocks of 5 items each follow. The final goal of "MapForcing" that file is a file, which has these "5 item blocks" as lines.
With FlexText I managed to
1. Split of the first line
2. Cut of the part of no interest from each line
3. Split the "5 item blocks"
To achieve goal 3, I used a regular expression. The problem is, that the data matching the regular expression is lost. Is there a way to avoid this?
|
|
