Community

To get the row value in single line even though it is in 2 lines

Avatar
Written by Permanently deleted user
  • 5

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??

Was this article helpful?

0 out of 0 found this helpful

Comments

5 comments

Sort by Date Votes
  • Avatar
    Permanently deleted user

    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

    0
  • Avatar
    Permanently deleted user

    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..

    0
  • Avatar
    Permanently deleted user

    Hey I found the solution..for this case

    1
  • Avatar
    Sara

    Hi Sunil,

    What is the solution for this?

    0
  • Avatar
    Permanently deleted user

    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

     

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post