Carriage Returns - TIME CRITICAL HELP!

[LaRetta]

I currently export a calc (BillingLine) to a tab-delimited file for electronic billing. I am getting claims rejections because of carriage returns appearing throughout. What is the best method of stripping these returns? Billing calc is (and I'll bet the forum squeezes together the spaces, but you'll get the gist)

Left(Provider & " ",20) & Left(SentTo & " ",12) & Case(IsEmpty(ConvDiag1), " ", Left(ConvDiag1 & " ",11) & Case(IsEmpty(ConvDiag2), " ", Left(ConvDiag2 & " " ,11) & Case(IsEmpty(ConvDiag3), " ", Left(ConvDiag3 & " ",11) & Case(IsEmpty(ConvCGAS), " ", Left(ConvCGAS & " ",6) & Case(IsEmpty(DiagSeq1)," ", Left(DiagSeq1 & " ",3) & Case(IsEmpty(DiagSeq2), " ", Left(DiagSeq2 & " ",3) & Case(IsEmpty(DiagSeq3), " ", Left(DiagSeq3 & " ",3) & Case(IsEmpty(ConvCGAS), " ", Left("4" & " ",4) & Case(IsEmpty(Locations::BillConversion), " ", Left(Locations::BillConversion & " ",5) & Left("S" & " ",4) & Left(ProcCode & " ",11) & Left(Units&" ",6) & Left(ConvLineTotal & " ",12) & Left( Invoice# & " ",10) & Left(ConvDate & " ",11) & Left(ConvDate & " ",11) & Left(HumanRes::StaffNameL & " ",29) & Left(Client::Medicaid# & " ",15) & Left(Client::cClientNameL & " ",36))))))))))

I think I need to address the issue of carriage returns in a broader sense, but these incorrect billing items need to be resolved soon. There are 50 spaces in various fields, and I'd rather NOT have to manually strip the spaces from each field in each record at this point. I'd like to just strip the billing calc so I can resubmit the billing. Suggestions?

[LaRetta]

I'm trying to pop this to the top of this list again, because I have 2 HOURS in which to correct this problem -- or over $10,000 of billings will be rejected!!! Can anyone please help me with stripping carriage returns from a calc -- without having to go through all these associated fields in three dbs individually?

[slstrother]

Create a new billingline field, call it billingline2, defined as text.

Create a script:

Go to Record/Request First

Loop

Set Field["billingline2,"billingline"]

Go to Record/Request [exit after last,next]

End Loop

This will place the contents of your calc field into a text field. Then use Replace to remove the carriage returns. Then export the billingline2 field. All of the carriage returns will be removed, do you need one at the end of each record?

[LaRetta]

Oh, thank you SO MUCH!!! No, I don't need a carriage return at the end. They map to my upload the way it is -- the carriage returns cause a rejection! Bless ya! I'll do it now

[LaRetta]

Help! I can't strip the carriage return from the text field!

[slstrother]

Replace by calculation

Substitute (billingline2, "

[LaRetta]

Just wanted to thank you all for helping me! Well, come to find out there were no carriage returns through this calc -- there was one carriage return at the end of the document. The reason the batch rejected was because our electronic clearing house had mis-mapped to my file and immediately jumped to the conclusion that it must be an error on this end because of the carriage returns!

Anyway, so I wasted three hours of my day on a non-existent issue! Thanks for helping me learn how to handle carriage returns, however! Learning something new makes it all worth it

[slstrother]

Not a problem, glad to help.