SpinText & Array Output

#1

Thanks for such a useful plugin.

What I have done:
Copied your example, selected an array which is 70 rows deep

What Happens:
Only two or three rows spin, then the rest of the rows repeat the same text.

What I need:
A full array of spun texts that will then become tweets (twitter requires unique content).

I don't understand:
a) why the spintext repeats and doesn't fill a full array with line after line of beautiful tweet material

b)

In the spintext example there is a "4" at the end of the string, what is that for?

SpinText(string spinText, [int alternatives, bool notRandom]) : array

Spins texts like {Niels|Nisse} is a SEO {n00b|expert}. Returns an array of spun texts.

#2

Can you give me an example of your "SpinText" input?

Try to use Dump or Resize for outputting the array.

The randomness of the SpinText (it's randomly selecting nodes; something I need to fix) isn't that good it's better to retrieve all combinations.

The number mean number of combinations to retrieve.

#3

This is the sort of set up (not the exact words), but you get the idea.

Unsure how DUMP or the RESIZE work....however, example:

=SpinText("{ONE|TWO|THREE|FOUR|FIVE|SIXE|SEVEN WORD EXAMPLE}", 100)


The aim is to create a spun XLS that can be uploaded to BulkBuffer for despatch via Buffer.

I wish Seo Tools had a way to create 100s of tweets AND most importantly Schedule them via Twiiter :smile:

#4

Try =Dump(SpinText("{ONE|TWO|THREE|FOUR|FIVE|SIXE|SEVEN WORD EXAMPLE}", 100))

Note that you example will only produce 7 permutations.

#5

I am trying to concatenate 2 different cells and then run spin text with the below function:

=CONCAT(N2;" - ";P2;" - ";SpinText(" {"&StringJoin("";"|")&"}""{ example 1 | example 2 | example 3 | example 4 | example 6} ";10))

but i am ending up with a result of concatenation of all examples in one cell whereas i would prefer them to shuffle from one cell to another.

any help on fixing the above function please?

Thanks,

#6

I don't understand the purpose of the StringJoin function, why are you using an empty string as input?

StringJoin("";"|")

#7

I just copied it from existing function that was working. Do you have any suggestions to what to remove the above function to get desired results? I am still ending up with concatenation of all examples despite of removing your suggested string.

#8

Can you send me an example file and show what your desired results should look like? I have no idea what you mean to be honest :slight_smile:

#9

image

I would like to concatenate values in column D and E and then shuffle some random CTA's on it to generate some meta data.

I hope you can help like you've always done :slight_smile:

#10

Try:
=B2 & " " & " " & C2 & " " & SpinText("{" & StringJoin($F$2:$F$6;"|") & "}")

1 Like
#11

superb.

I just needed the 2nd part SpinText("{" & StringJoin($F$2:$F$6;"|") & "}")

and it works with my existing function.

Thanks a bunch :slight_smile:

1 Like