Hi,
I have a PO which contains several number of line items(Structure is same). So i made one layout and i am able to get the data from all the rows and i am exporting it in Excel. The problem here is, In some columns data is in 2 lines like, for suppose if we take MRP it is 1895.00. On PO it is printed as 1895 in one line and .00 in another line. So in Excel I am getting space for 1895 and .00.
So, how could i get recognize this in a single line?? Because i want to remove that space in Excel??
コメント
5件のコメント
Hi Sunil,
You could use an auto correct script to remove spaces thus making your field "1895.00" rather than "1895 .00". Let me know if this does not work or you need help with the script.
-Collins Sarmento
Hi Collins,
Thanks for your reply, actually that is not the case for me..Kindly, check the attachment, So that you can understand my scenario.
I have tried what you said, but it's still having a space..
Hey I found the solution..for this case
Hi Sunil,
What is the solution for this?
Hello,
I think the solution for this is to create a Group in the elements which will contains the 2 elements (StaticText)
1 part on the first ligne and 2 part on the seconde ligne "1895.00."
Then in the block you should indicate whole the group " .00. "
Best Regards,
Hamdi
サインインしてコメントを残してください。