Back

If your email is not recognized and you believe it should be, please contact us.

Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • May 21, 2020 at 6:17 am in reply to: GREP Styles Quick formatting help #1251984
    Stan Cain
    Member

    In all of the records, there is always 11 Numbers (digits) before the name begins

    May 21, 2020 at 6:14 am in reply to: GREP Styles Quick formatting help #125175
    Stan Cain
    Member

    That actually is not working because some of the names are like this with numbers
    000000079 01 02050801120250FLORIDA INVEST LLC $527.06
    The actual company name is 250 FLORIDA INVEST LLC so the space would need to be added between 2 numbers

    May 21, 2020 at 5:29 am in reply to: GREP Styles Quick formatting help #125173
    Stan Cain
    Member

    Thanks for your response David, I was actually able to figure out most of it by doing some research here and theres only 1 Issue that I cannot figure out, after I have the number formatted like this: 000000098 01 31110331730ROBER ARENA I Cannot find a way to select and add the space at the end of the number string between the beginning of the Name/company.

    I use (Space) 0+(\d\d\d)0+\d\d(\d\d\d\d) and change to $0 (space)
    and it works on some of the records but not others.

    April 23, 2020 at 8:55 am in reply to: GREP Styles Help #1240189
    Stan Cain
    Member

    This is working Perfectly David, I will go through and do all the updates and let you know, HUGE THANKS AGAIN.

    April 23, 2020 at 7:43 am in reply to: GREP Styles Help #1240169
    Stan Cain
    Member

    Thank You David, I have been looking at this morning.

    April 23, 2020 at 7:42 am in reply to: GREP Styles Help #1240159
    Stan Cain
    Member

    Your help has been greatly appreciated Aaron, I do notice that when I do the string 0+(\d\d\d)(\d\d) R it misses some of the records, seems like it misses the ones with 9 zeroes before a number EXAMPLE (0000007 COMPANY NAME 000000000870998 R) It passes over all of the records with 9 zeroes.

    So I edited the string to 0+(\d\d\d)(\d\d\d) R and to be replaced with $$1.$2 and run it again to catch the leftovers and it puts the decimal in the wrong location example ( $870.998), need it before the last 2 digits not 3.

    April 22, 2020 at 12:42 pm in reply to: GREP Styles Help #1240029
    Stan Cain
    Member

    Ok, I think I got that section perfect, Thank you Aaron, Now how do I add a convert multiple spaces (It will be different, based on the names on) into a single TAB

    April 22, 2020 at 12:14 pm in reply to: GREP Styles Help #1239999
    Stan Cain
    Member

    Aaron, David, You Guys are AWESOME, I am finally making some headway after more than a week! quick edit, If I need to move the decimal to be in front of the 2 digit cents (EXAMPLE) change FROM 000000000049885 TO $498.85 How do I update $$1.$2

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)