Is there any Trim() like Function of Excel in Tally

Dear Amitji / Experts
Is there any Function or Code in Tally like Trim() in Excel. Actually when I try to import
some bank statements from excel to Tally some amount fields need to use Trim() in excel... then only they are
imported correctly. So if there is any Trim like code which will fecch that Column data from Excel using Tallys
Trim Function/Code.
Thanks

 

I guess you can use Find and Replace Function where you can replace double spaces (" ")

 

There is a function called "Trimspaces", try that

 

If You Wants to Remove Spaces Between Then Try This One.

$$RemoveSpaces

Many Other Also Available For Non Numeric,Alpha Numeric Etc.

 

Sir how to remove Linefeed character 10 and 13

 

We can use TrimSpaces function
$$TrimSpaces:" text with spaces as prefix and suffix "

 

Use StringFindAndReplace
$$StringFindAndReplace" 0,fgh ghjk" + $$StrByCharcode:13)$$StrByCharcode:13):""

 

Working Fine, Thanks