Negative in parenthesis

I should add is that there is a working demo I created a few years ago that demonstrates this technique.

If you download this CSVish file:

https://haversineconsulting.quickbase.com/db/bjfwg3cwb?a=dbpage&pagename=data.txt

You can import it into this application:

https://haversineconsulting.quickbase.com/db/bjfwg3cwb

This file is CSVish because it has two header columns, separates data with pipe characters.

The custom processing logic performs these three cleanup steps:

1. Concatenates the first and last names into a single field
2. Normalizes spelled out states to have two letter abbreviations
3. Normalizes emails to be all lower case

Here is a fragment of code that process each line:

csv_line.push(row["First Name"] + " " + row["Last Name"]); csv_line.push(row["Address"]);
csv_line.push(row["City"]);
if (row["State"].length > 2) {
  csv_line.push(states[row["State"].toLowerCase()]);
} else {
  csv_line.push(row["State"]);
}
csv_line.push(row["Zip"]); csv_line.push(row["Email"].toLowerCase());

It would be a simple matter to perform the parentheses processing.

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=356

If you need individual assistance with this task please feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt