I am trying to modify 2 fields (Customer name, customer number) that are shown below and add some text also.
AUTO SALON FIN363
I need the output to look like
1,,"auto salon","fin363",,,,,,,,,,,,,,,$0.00,,,0
Note that the numbers, quotes, and commas must all be added. I have tried using cocatenate but either I am doing it wrong or maybe that is not the correct function?
Any help will be greatly appreciated. I am ready to pull my hair out with this one.......
Boycott Sony
AUTO SALON FIN363
I need the output to look like
1,,"auto salon","fin363",,,,,,,,,,,,,,,$0.00,,,0
Note that the numbers, quotes, and commas must all be added. I have tried using cocatenate but either I am doing it wrong or maybe that is not the correct function?
Any help will be greatly appreciated. I am ready to pull my hair out with this one.......
Boycott Sony