Results 1 to 3 of 3

Replace Text

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Replace Text

    Hello,

    I am readng some text data from a file. The format of the text is:

    ASPUL -16.00E-03 -17.00E-03 -18.00E-03 -19.00E-03 -20.00E-03 +
    -21.00E-03 -22.00E-03 -23.00E-03 -24.00E-03 -25.00E-03 +
    -26.00E-03 -27.00E-03 -28.00E-03 -29.00E-03 -30.00E-03 +

    I would like to replace ASPUL with ASPULN. I am reading the data using the line code

    Line Input #iAxialProfFileMinNum, LineData


    My problem is that the numbers followed by ASPUL can change bazed on certain other factors.
    I need a logic that will let me split the string into 2 strings with a space separator, changing the first string to ASPULN and then appending the second string consisting of the numbers.
    Any ideas as to how to do this? or any other better way

    Thanks

    Paras
    Last edited by parasbshah; 07-18-2011 at 09:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1