DataMystic

Another small problem:

Format:
1001|First Company|USA|First Address|other fields

I have several hundreds of files with random filename with this format.

I would like to create USA.dump file and UK.dump file etc per each country found in all files.

I made extract with all Country names and ...

I am testing to see if Textpipe Pro can help us find amounts in database dumps.

The main problem is that an amount can have different format because different international formats.

Example:
230,000.00 (normal US Format)
230.000,00 (normal EU format)
230000.00 (abbr US format)
230000,00 (abbr EU ...