Hi and welcome,
I assume all the other combinations have just one space between the account number and the accouint name? Very annoying as you almost certainly have to assume that all the fields need to be processed.
One way or another you are looking at creating a calculated field to replace the extraction or extractions made for the table. There are several ways to do what you need to do.
Have you extracted the account number and the description as one field or two separate fields?
If as one field you can remove the hyphen using the STRIP function. But you will be left with a double space instead of a single space.
The space scanrio can be resolved by splitting the account number off the front of the field (see the LSPLIT function) and the doing removing the leading spaces from the second part of the field using the LTRIM function and then concatenataing them together once again with a space.
(NB. For any Version 8 users reading this - you could so this but version 8 has some additional functions which should make the process simpler in most cases.)
If you are already picking the fields separately you need only process the NAME field before concatenating with the number field.
[font="courier"][number field]" "(LTRIM(STRIP(,"-"))) /font[/quote]Should give you what you want. Providing none on the have valid hyphens that you need to retain later in the string.
The 'Single Field' solution could be worked almost the same way if you first split the field into 2 parts based on the first space after the number.
Have a look at the Functions References in the Help files. Also you should find a Functions Reference document in PDF format for download from the Datawatch web site.
If none of these suggestion are suitable let us know and we can get into the trickier stuff ... :cool:
As a sidenote: Monarch V8 users can combine the Strip function as noted by Grant with the InTrim function, which replaces instances of multiple spaces in a text string with single spaces. InTrim also removes leading and trailing spaces.
So the best Monarch V8 formula to turn data such as:
11300 - INVENTORY
Product Marketing Manager