Re: [MSAccessProfessionals] indent string to the right by space characters

Could you count the periods in the string then add that number of spaces to the string

James Hundley

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of smiley2004_10 <cas23121964@gmail.com>
Sent: Thursday, September 23, 2021 7:42:16 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] indent string to the right by space characters

 

Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks